Bentley Substation Help

Configure Databases

Lets you create a new database or select an existing database for a new project.

Accessed when:

SettingDescription
New Database Displays the Project Database Utility dialog where the user can either create a new project database, or upgrade an existing one.
Server Name User can install an instance of SQL Server 2008 on the local machine. The Server name field displays the default local server name (local)\BENTLEYECAD. The parameter (local) is a special variable that automatically matches the name of your computer so it is not necessary to enter your computer name if you use this parameter.

If you wish to configure the software to look at a different database server then you must enter the appropriate server and instance name. The format should be as follows:

YourServerName\Instance

Example: MyServer\BENTLEYECAD

Separate Database Per Project This forces the user to create a separate database per project.
Dyamically switch databases in project manager This option determines how the software behaves in the multiple database strategy. If you have two projects created in two different databases and select Project 1, it will switch the database connection to the database that Project 1 was created in. If you now select Project 2 it will switch the database connection to Project 2's database and allow you to open it.

When this option is disabled, the default database called out in this same setup dialog is the only database you can connect to. Any project that belongs to a different database is marked with a red circle on the project folder indicating it is inaccessible.

Default database name Enter the name of the Bentley Substation database to which you wish to connect. By default, the software creates a database named Substation.
Note: If you install the software again without deleting the original database, the installation will connect to your existing database provided that the new version of Bentley Substation does not require a newer version of the database. If the installation does require a newer version of the database, it will create a new database named "promise1" so that it does not overwrite your previous database.
Windows authentication Windows Authentication will use the user's Windows login name to determine what security rights they have to the database.
SQL server authentication The database administrator will have to create a login and password for the user in SQL server. Enter this login and password in the login and password fields.
Note: The Login name and Password fields are only enabled when this option is selected.